﻿<?xml version="1.0" encoding="utf-8" ?>
<settings defaultOrderBy='value'>
  <module>Pacm</module>
  <select>text,value, pid, remark</select>
  <from>
    (
    select Sbgzlb_Lbbh as value,Sbgzlb_Lbmc as text,Sbgzlb_Sjbh as pid,Sbgzlb_Remark as remark from b_Sbgzlb
    union all
    select Sbgzyy_Yybh as value,Sbgzyy_Yymc as text,Sbgzyy_Lbbh as pid ,Sbgzyy_Yyms as remark from b_Sbgzyy
    ) A
  </from>
  <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
    <field name='text'       cp='like'  ></field>
    <field name='value'      cp='startwith'       ></field>
  </where>
</settings>